Overview

Brought to you by YData

Dataset statistics

Number of variables	27
Number of observations	899164
Missing cells	751259
Missing cells (%)	3.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	185.2 MiB
Average record size in memory	216.0 B

Variable types

Numeric	8
Text	9
DateTime	3
Unsupported	1
Categorical	6

Alerts

`RevLineCr` is highly imbalanced (61.3%)	Imbalance
`LowDoc` is highly imbalanced (80.6%)	Imbalance
`BalanceGross` is highly imbalanced (> 99.9%)	Imbalance
`ChgOffDate` has 736465 (81.9%) missing values	Missing
`NoEmp` is highly skewed (γ1 = 80.24824355)	Skewed
`CreateJob` is highly skewed (γ1 = 36.99135473)	Skewed
`RetainedJob` is highly skewed (γ1 = 36.85481184)	Skewed
`LoanNr_ChkDgt` has unique values	Unique
`ApprovalFY` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`NAICS` has 201948 (22.5%) zeros	Zeros
`CreateJob` has 629248 (70.0%) zeros	Zeros
`RetainedJob` has 440403 (49.0%) zeros	Zeros
`FranchiseCode` has 208835 (23.2%) zeros	Zeros

Reproduction

Analysis started	2025-02-09 08:22:02.379166
Analysis finished	2025-02-09 08:23:28.343758
Duration	1 minute and 25.96 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

LoanNr_ChkDgt
Real number (ℝ)

Unique

Distinct	899164
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.7726123 × 10⁹

Minimum	1.000014 × 10⁹
Maximum	9.996003 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1.000014 × 10⁹
5-th percentile	1.3484572 × 10⁹
Q1	2.5897575 × 10⁹
median	4.361439 × 10⁹
Q3	6.9046265 × 10⁹
95-th percentile	9.1648039 × 10⁹
Maximum	9.996003 × 10⁹
Range	8.995989 × 10⁹
Interquartile range (IQR)	4.314869 × 10⁹

Descriptive statistics

Standard deviation	2.538175 × 10⁹
Coefficient of variation (CV)	0.53182091
Kurtosis	-1.086499
Mean	4.7726123 × 10⁹
Median Absolute Deviation (MAD)	2.0134 × 10⁹
Skewness	0.3647571
Sum	4.2913612 × 10¹⁵
Variance	6.4423325 × 10¹⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9996003010	1	< 0.1%
1000014003	1	< 0.1%
1000024006	1	< 0.1%
1000034009	1	< 0.1%
1000044001	1	< 0.1%
1000054004	1	< 0.1%
1000084002	1	< 0.1%
1000093009	1	< 0.1%
1000094005	1	< 0.1%
1000104006	1	< 0.1%
Other values (899154)	899154	> 99.9%

Value	Count	Frequency (%)
1000014003	1	< 0.1%
1000024006	1	< 0.1%
1000034009	1	< 0.1%
1000044001	1	< 0.1%
1000054004	1	< 0.1%
1000084002	1	< 0.1%
1000093009	1	< 0.1%
1000094005	1	< 0.1%
1000104006	1	< 0.1%
1000124001	1	< 0.1%

Value	Count	Frequency (%)
9996003010	1	< 0.1%
9995973006	1	< 0.1%
9995613003	1	< 0.1%
9995603000	1	< 0.1%
9995573004	1	< 0.1%
9995563001	1	< 0.1%
9995493004	1	< 0.1%
9995473009	1	< 0.1%
9995453003	1	< 0.1%
9995423005	1	< 0.1%

Name
Text

Distinct	779583
Distinct (%)	86.7%
Missing	14
Missing (%)	< 0.1%
Memory size	6.9 MiB

Length

Max length	30
Median length	23
Mean length	21.775963
Min length	1

Characters and Unicode

Total characters	19579857
Distinct characters	91
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	706468 ?
Unique (%)	78.6%

Sample

1st row	ABC HOBBYCRAFT
2nd row	LANDMARK BAR & GRILLE (THE)
3rd row	WHITLOCK DDS, TODD M.
4th row	BIG BUCKS PAWN & JEWELRY, LLC
5th row	ANASTASIA CONFECTIONS, INC.

Value	Count	Frequency (%)
inc	263379	8.4%
	100280	3.2%
llc	77826	2.5%
and	28959	0.9%
the	28389	0.9%
of	23026	0.7%
dba	20214	0.6%
co	18216	0.6%
a	18114	0.6%
services	17318	0.6%
Other values (226643)	2530176	80.9%

Most occurring characters

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19579857	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19579857	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19579857	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	2231639	11.4%
E	1354056	6.9%
I	1226719	6.3%
A	1177821	6.0%
N	1170319	6.0%
R	1052562	5.4%
C	1038114	5.3%
S	1009495	5.2%
O	933206	4.8%
T	917437	4.7%
Other values (81)	7468489	38.1%

City
Text

Distinct	32581
Distinct (%)	3.6%
Missing	30
Missing (%)	< 0.1%
Memory size	6.9 MiB

Length

Max length	30
Median length	27
Mean length	9.1030625
Min length	1

Characters and Unicode

Total characters	8184873
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12872 ?
Unique (%)	1.4%

Sample

1st row	EVANSVILLE
2nd row	NEW PARIS
3rd row	BLOOMINGTON
4th row	BROKEN ARROW
5th row	ORLANDO

Value	Count	Frequency (%)
city	23831	2.0%
san	21942	1.8%
new	16075	1.3%
los	13000	1.1%
angeles	12380	1.0%
lake	10729	0.9%
houston	10587	0.9%
beach	10462	0.9%
park	10316	0.9%
york	9724	0.8%
Other values (17695)	1066583	88.5%

Most occurring characters

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8184873	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8184873	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8184873	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	744405	9.1%
E	723098	8.8%
O	632510	7.7%
N	621338	7.6%
L	573578	7.0%
R	513614	6.3%
S	475392	5.8%
I	468344	5.7%
T	425108	5.2%
	306936	3.8%
Other values (70)	2700550	33.0%

State
Text

Distinct	51
Distinct (%)	< 0.1%
Missing	14
Missing (%)	< 0.1%
Memory size	6.9 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1798300
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IN
2nd row	IN
3rd row	IN
4th row	OK
5th row	FL

Value	Count	Frequency (%)
ca	130619	14.5%
tx	70458	7.8%
ny	57693	6.4%
fl	41212	4.6%
pa	35170	3.9%
oh	32622	3.6%
il	29669	3.3%
ma	25272	2.8%
mn	24373	2.7%
nj	24035	2.7%
Other values (41)	428027	47.6%

Most occurring characters

Value	Count	Frequency (%)
A	306176	17.0%
C	184957	10.3%
N	181727	10.1%
M	132549	7.4%
T	125069	7.0%
I	119518	6.6%
O	94906	5.3%
L	88819	4.9%
X	70458	3.9%
Y	68255	3.8%
Other values (14)	425866	23.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1798300	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	306176	17.0%
C	184957	10.3%
N	181727	10.1%
M	132549	7.4%
T	125069	7.0%
I	119518	6.6%
O	94906	5.3%
L	88819	4.9%
X	70458	3.9%
Y	68255	3.8%
Other values (14)	425866	23.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1798300	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	306176	17.0%
C	184957	10.3%
N	181727	10.1%
M	132549	7.4%
T	125069	7.0%
I	119518	6.6%
O	94906	5.3%
L	88819	4.9%
X	70458	3.9%
Y	68255	3.8%
Other values (14)	425866	23.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1798300	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	306176	17.0%
C	184957	10.3%
N	181727	10.1%
M	132549	7.4%
T	125069	7.0%
I	119518	6.6%
O	94906	5.3%
L	88819	4.9%
X	70458	3.9%
Y	68255	3.8%
Other values (14)	425866	23.7%

Zip
Real number (ℝ)

Distinct	33611
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53804.391

Minimum	0
Maximum	99999
Zeros	283
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	3838
Q1	27587
median	55410
Q3	83704
95-th percentile	95822
Maximum	99999
Range	99999
Interquartile range (IQR)	56117

Descriptive statistics

Standard deviation	31184.159
Coefficient of variation (CV)	0.5795839
Kurtosis	-1.3359893
Mean	53804.391
Median Absolute Deviation (MAD)	28206
Skewness	-0.16816663
Sum	4.8378972 × 10¹⁰
Variance	9.7245178 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10001	933	0.1%
90015	926	0.1%
93401	806	0.1%
90010	733	0.1%
33166	671	0.1%
90021	666	0.1%
59601	640	0.1%
65804	599	0.1%
3801	581	0.1%
59101	578	0.1%
Other values (33601)	892031	99.2%

Value	Count	Frequency (%)
0	283	< 0.1%
1	24	< 0.1%
2	11	< 0.1%
3	5	< 0.1%
4	5	< 0.1%
5	5	< 0.1%
6	4	< 0.1%
7	6	< 0.1%
8	15	< 0.1%
9	24	< 0.1%

Value	Count	Frequency (%)
99999	209	< 0.1%
99950	3	< 0.1%
99929	15	< 0.1%
99928	1	< 0.1%
99926	1	< 0.1%
99925	4	< 0.1%
99923	1	< 0.1%
99921	13	< 0.1%
99919	2	< 0.1%
99918	1	< 0.1%

Bank
Text

Distinct	5802
Distinct (%)	0.6%
Missing	1559
Missing (%)	0.2%
Memory size	6.9 MiB

Length

Max length	30
Median length	26
Mean length	23.187946
Min length	3

Characters and Unicode

Total characters	20813616
Distinct characters	50
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	923 ?
Unique (%)	0.1%

Sample

1st row	FIFTH THIRD BANK
2nd row	1ST SOURCE BANK
3rd row	GRANT COUNTY STATE BANK
4th row	1ST NATL BK & TR CO OF BROKEN
5th row	FLORIDA BUS. DEVEL CORP

Value	Count	Frequency (%)
bank	651608	18.5%
natl	318240	9.0%
assoc	306768	8.7%
of	142852	4.1%
national	125899	3.6%
america	100686	2.9%
association	84965	2.4%
fargo	63732	1.8%
wells	63650	1.8%
	52264	1.5%
Other values (3602)	1606709	45.7%

Most occurring characters

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20813616	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20813616	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20813616	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	2762231	13.3%
	2620014	12.6%
N	2105500	10.1%
S	1520499	7.3%
O	1336993	6.4%
T	1181841	5.7%
C	1134642	5.5%
I	1061717	5.1%
E	923739	4.4%
L	922583	4.4%
Other values (40)	5243857	25.2%

BankState
Text

Distinct	56
Distinct (%)	< 0.1%
Missing	1566
Missing (%)	0.2%
Memory size	6.9 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1795196
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	OH
2nd row	IN
3rd row	IN
4th row	OK
5th row	FL

Value	Count	Frequency (%)
ca	118116	13.2%
nc	79514	8.9%
il	65908	7.3%
oh	58461	6.5%
sd	51095	5.7%
tx	47790	5.3%
ri	45366	5.1%
ny	39592	4.4%
va	29002	3.2%
de	24537	2.7%
Other values (46)	338217	37.7%

Most occurring characters

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1795196	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1795196	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1795196	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	241398	13.4%
C	229604	12.8%
N	187751	10.5%
I	158854	8.8%
O	102604	5.7%
L	96914	5.4%
D	96078	5.4%
T	94941	5.3%
M	85034	4.7%
S	73385	4.1%
Other values (14)	428633	23.9%

NAICS
Real number (ℝ)

Zeros

Distinct	1312
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	398660.95

Minimum	0
Maximum	928120
Zeros	201948
Zeros (%)	22.5%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	235210
median	445310
Q3	561730
95-th percentile	811192
Maximum	928120
Range	928120
Interquartile range (IQR)	326520

Descriptive statistics

Standard deviation	263318.31
Coefficient of variation (CV)	0.66050691
Kurtosis	-1.0476526
Mean	398660.95
Median Absolute Deviation (MAD)	176300
Skewness	-0.26287834
Sum	3.5846157 × 10¹¹
Variance	6.9336534 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	201948	22.5%
722110	27989	3.1%
722211	19448	2.2%
811111	14585	1.6%
621210	14048	1.6%
624410	10111	1.1%
812112	9230	1.0%
561730	8935	1.0%
621310	8733	1.0%
812320	7894	0.9%
Other values (1302)	576243	64.1%

Value	Count	Frequency (%)
0	201948	22.5%
111110	32	< 0.1%
111120	3	< 0.1%
111130	1	< 0.1%
111140	94	< 0.1%
111150	49	< 0.1%
111160	2	< 0.1%
111191	3	< 0.1%
111199	7	< 0.1%
111211	16	< 0.1%

Value	Count	Frequency (%)
928120	32	< 0.1%
928110	4	< 0.1%
927110	1	< 0.1%
926150	10	< 0.1%
926140	6	< 0.1%
926130	3	< 0.1%
926120	5	< 0.1%
926110	6	< 0.1%
925120	1	< 0.1%
925110	3	< 0.1%

ApprovalDate
Date

Distinct	9859
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Minimum	1975-01-20 00:00:00
Maximum	2074-12-17 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

ApprovalFY
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Term
Real number (ℝ)

Distinct	412
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	110.77308

Minimum	0
Maximum	569
Zeros	810
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	16
Q1	60
median	84
Q3	120
95-th percentile	300
Maximum	569
Range	569
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	78.857305
Coefficient of variation (CV)	0.7118815
Kurtosis	0.18570424
Mean	110.77308
Median Absolute Deviation (MAD)	33
Skewness	1.1209258
Sum	99603164
Variance	6218.4746
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
84	230162	25.6%
60	89945	10.0%
240	85982	9.6%
120	77654	8.6%
300	44727	5.0%
180	28164	3.1%
36	19800	2.2%
12	17095	1.9%
48	15621	1.7%
72	9419	1.0%
Other values (402)	280595	31.2%

Value	Count	Frequency (%)
0	810	0.1%
1	1608	0.2%
2	1809	0.2%
3	2112	0.2%
4	2173	0.2%
5	1866	0.2%
6	3054	0.3%
7	1761	0.2%
8	1693	0.2%
9	1875	0.2%

Value	Count	Frequency (%)
569	1	< 0.1%
527	1	< 0.1%
511	1	< 0.1%
505	1	< 0.1%
481	1	< 0.1%
480	1	< 0.1%
461	1	< 0.1%
449	1	< 0.1%
445	1	< 0.1%
443	1	< 0.1%

NoEmp
Real number (ℝ)

Skewed

Distinct	599
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.411353

Minimum	0
Maximum	9999
Zeros	6631
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	4
Q3	10
95-th percentile	40
Maximum	9999
Range	9999
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	74.108196
Coefficient of variation (CV)	6.4942514
Kurtosis	7965.2886
Mean	11.411353
Median Absolute Deviation (MAD)	3
Skewness	80.248244
Sum	10260678
Variance	5492.0248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	154254	17.2%
2	138297	15.4%
3	90674	10.1%
4	73644	8.2%
5	60319	6.7%
6	45759	5.1%
10	31536	3.5%
7	31495	3.5%
8	31361	3.5%
12	20822	2.3%
Other values (589)	221003	24.6%

Value	Count	Frequency (%)
0	6631	0.7%
1	154254	17.2%
2	138297	15.4%
3	90674	10.1%
4	73644	8.2%
5	60319	6.7%
6	45759	5.1%
7	31495	3.5%
8	31361	3.5%
9	18131	2.0%

Value	Count	Frequency (%)
9999	4	< 0.1%
9992	1	< 0.1%
9945	1	< 0.1%
9090	1	< 0.1%
9000	2	< 0.1%
8500	1	< 0.1%
8041	1	< 0.1%
8018	1	< 0.1%
8000	7	< 0.1%
7999	1	< 0.1%

NewExist
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	136
Missing (%)	< 0.1%
Memory size	6.9 MiB

1.0	644869
2.0	253125
0.0	1034

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2697084
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	644869	71.7%
2.0	253125	28.2%
0.0	1034	0.1%
(Missing)	136	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	644869	71.7%
2.0	253125	28.2%
0.0	1034	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2697084	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2697084	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2697084	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	900062	33.4%
.	899028	33.3%
1	644869	23.9%
2	253125	9.4%

CreateJob
Real number (ℝ)

Skewed Zeros

Distinct	246
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.4303764

Minimum	0
Maximum	8800
Zeros	629248
Zeros (%)	70.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	10
Maximum	8800
Range	8800
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	236.68817
Coefficient of variation (CV)	28.075634
Kurtosis	1369.911
Mean	8.4303764
Median Absolute Deviation (MAD)	0
Skewness	36.991355
Sum	7580291
Variance	56021.288
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	629248	70.0%
1	63174	7.0%
2	57831	6.4%
3	28806	3.2%
4	20511	2.3%
5	18691	2.1%
10	11602	1.3%
6	11009	1.2%
8	7378	0.8%
7	6374	0.7%
Other values (236)	44540	5.0%

Value	Count	Frequency (%)
0	629248	70.0%
1	63174	7.0%
2	57831	6.4%
3	28806	3.2%
4	20511	2.3%
5	18691	2.1%
6	11009	1.2%
7	6374	0.7%
8	7378	0.8%
9	3330	0.4%

Value	Count	Frequency (%)
8800	648	0.1%
5621	1	< 0.1%
5199	1	< 0.1%
5085	1	< 0.1%
3500	1	< 0.1%
3100	1	< 0.1%
3000	4	< 0.1%
2515	1	< 0.1%
2140	1	< 0.1%
2020	1	< 0.1%

RetainedJob
Real number (ℝ)

Skewed Zeros

Distinct	358
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.797257

Minimum	0
Maximum	9500
Zeros	440403
Zeros (%)	49.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	20
Maximum	9500
Range	9500
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	237.1206
Coefficient of variation (CV)	21.961188
Kurtosis	1362.0182
Mean	10.797257
Median Absolute Deviation (MAD)	1
Skewness	36.854812
Sum	9708505
Variance	56226.179
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	440403	49.0%
1	88790	9.9%
2	76851	8.5%
3	49963	5.6%
4	39666	4.4%
5	32627	3.6%
6	23796	2.6%
7	16530	1.8%
8	15698	1.7%
10	15438	1.7%
Other values (348)	99402	11.1%

Value	Count	Frequency (%)
0	440403	49.0%
1	88790	9.9%
2	76851	8.5%
3	49963	5.6%
4	39666	4.4%
5	32627	3.6%
6	23796	2.6%
7	16530	1.8%
8	15698	1.7%
9	8735	1.0%

Value	Count	Frequency (%)
9500	1	< 0.1%
8800	648	0.1%
7250	1	< 0.1%
5000	1	< 0.1%
4441	1	< 0.1%
4000	2	< 0.1%
3900	1	< 0.1%
3860	1	< 0.1%
3225	1	< 0.1%
3200	1	< 0.1%

FranchiseCode
Real number (ℝ)

Zeros

Distinct	2768
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2753.7259

Minimum	0
Maximum	99999
Zeros	208835
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	15805
Maximum	99999
Range	99999
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12758.019
Coefficient of variation (CV)	4.6330025
Kurtosis	24.409524
Mean	2753.7259
Median Absolute Deviation (MAD)	0
Skewness	4.9752152
Sum	2.4760512 × 10⁹
Variance	1.6276705 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	638554	71.0%
0	208835	23.2%
78760	3373	0.4%
68020	1921	0.2%
50564	1034	0.1%
21780	1003	0.1%
25650	715	0.1%
79140	659	0.1%
22470	615	0.1%
17998	606	0.1%
Other values (2758)	41849	4.7%

Value	Count	Frequency (%)
0	208835	23.2%
1	638554	71.0%
3	12	< 0.1%
395	5	< 0.1%
399	3	< 0.1%
400	2	< 0.1%
401	12	< 0.1%
404	1	< 0.1%
407	34	< 0.1%
414	2	< 0.1%

Value	Count	Frequency (%)
99999	1	< 0.1%
92006	4	< 0.1%
92000	9	< 0.1%
91999	11	< 0.1%
91450	2	< 0.1%
91446	1	< 0.1%
91443	2	< 0.1%
91435	1	< 0.1%
91424	1	< 0.1%
91423	2	< 0.1%

UrbanRural
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

1	470654
0	323167
2	105343

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	899164
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring characters

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	899164	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	470654	52.3%
0	323167	35.9%
2	105343	11.7%

RevLineCr
Categorical

Imbalance

Distinct	18
Distinct (%)	< 0.1%
Missing	4528
Missing (%)	0.5%
Memory size	6.9 MiB

N	420288
0	257602
Y	201397
T	15284
1	23
Other values (13)	42

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	894636
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	420288	46.7%
0	257602	28.6%
Y	201397	22.4%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%
(Missing)	4528	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
n	420288	47.0%
0	257602	28.8%
y	201397	22.5%
t	15284	1.7%
1	23	< 0.1%
r	14	< 0.1%
	14	< 0.1%
2	6	< 0.1%
c	2	< 0.1%
3	1	< 0.1%
Other values (5)	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	894636	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	894636	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	894636	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	420288	47.0%
0	257602	28.8%
Y	201397	22.5%
T	15284	1.7%
1	23	< 0.1%
R	14	< 0.1%
`	11	< 0.1%
2	6	< 0.1%
C	2	< 0.1%
,	1	< 0.1%
Other values (8)	8	< 0.1%

LowDoc
Categorical

Imbalance

Distinct	8
Distinct (%)	< 0.1%
Missing	2582
Missing (%)	0.3%
Memory size	6.9 MiB

N	782822
Y	110335
0	1491
C	758
S	603
Other values (3)	573

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	896582
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Y
2nd row	Y
3rd row	N
4th row	Y
5th row	N

Common Values

Value	Count	Frequency (%)
N	782822	87.1%
Y	110335	12.3%
0	1491	0.2%
C	758	0.1%
S	603	0.1%
A	497	0.1%
R	75	< 0.1%
1	1	< 0.1%
(Missing)	2582	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	782822	87.3%
y	110335	12.3%
0	1491	0.2%
c	758	0.1%
s	603	0.1%
a	497	0.1%
r	75	< 0.1%
1	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	782822	87.3%
Y	110335	12.3%
0	1491	0.2%
C	758	0.1%
S	603	0.1%
A	497	0.1%
R	75	< 0.1%
1	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	896582	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	782822	87.3%
Y	110335	12.3%
0	1491	0.2%
C	758	0.1%
S	603	0.1%
A	497	0.1%
R	75	< 0.1%
1	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	896582	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	782822	87.3%
Y	110335	12.3%
0	1491	0.2%
C	758	0.1%
S	603	0.1%
A	497	0.1%
R	75	< 0.1%
1	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	896582	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	782822	87.3%
Y	110335	12.3%
0	1491	0.2%
C	758	0.1%
S	603	0.1%
A	497	0.1%
R	75	< 0.1%
1	1	< 0.1%

ChgOffDate
Date

Missing

Distinct	6448
Distinct (%)	4.0%
Missing	736465
Missing (%)	81.9%
Memory size	6.9 MiB

Minimum	1988-10-03 00:00:00
Maximum	2026-10-22 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

DisbursementDate
Date

Distinct	8472
Distinct (%)	0.9%
Missing	2368
Missing (%)	0.3%
Memory size	6.9 MiB

Minimum	1975-01-17 00:00:00
Maximum	2074-12-04 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

DisbursementGross
Text

Distinct	118859
Distinct (%)	13.2%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	15
Median length	14
Mean length	11.537586
Min length	6

Characters and Unicode

Total characters	10374182
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	79785 ?
Unique (%)	8.9%

Sample

1st row	$60,000.00
2nd row	$40,000.00
3rd row	$287,000.00
4th row	$35,000.00
5th row	$229,000.00

Value	Count	Frequency (%)
50,000.00	43787	4.9%
100,000.00	36714	4.1%
25,000.00	27387	3.0%
150,000.00	23373	2.6%
10,000.00	21328	2.4%
35,000.00	14748	1.6%
5,000.00	14193	1.6%
75,000.00	13528	1.5%
20,000.00	13462	1.5%
30,000.00	12696	1.4%
Other values (118849)	677948	75.4%

Most occurring characters

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10374182	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10374182	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10374182	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4457089	43.0%
,	924978	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	445569	4.3%
1	409947	4.0%
2	312909	3.0%
3	238773	2.3%
4	207077	2.0%
Other values (4)	680348	6.6%

BalanceGross
Categorical

Imbalance

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

$0.00	899150
$12,750.00	1
$827,875.00	1
$25,000.00	1
$37,100.00	1
Other values (10)	10

Length

Max length	12
Median length	6
Mean length	6.0000767
Min length	6

Characters and Unicode

Total characters	5395053
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	< 0.1%

Sample

1st row	$0.00
2nd row	$0.00
3rd row	$0.00
4th row	$0.00
5th row	$0.00

Common Values

Value	Count	Frequency (%)
$0.00	899150	> 99.9%
$12,750.00	1	< 0.1%
$827,875.00	1	< 0.1%
$25,000.00	1	< 0.1%
$37,100.00	1	< 0.1%
$43,127.00	1	< 0.1%
$84,617.00	1	< 0.1%
$1,760.00	1	< 0.1%
$115,820.00	1	< 0.1%
$996,262.00	1	< 0.1%
Other values (5)	5	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0.00	899150	> 99.9%
12,750.00	1	< 0.1%
827,875.00	1	< 0.1%
25,000.00	1	< 0.1%
37,100.00	1	< 0.1%
43,127.00	1	< 0.1%
84,617.00	1	< 0.1%
1,760.00	1	< 0.1%
115,820.00	1	< 0.1%
996,262.00	1	< 0.1%
Other values (5)	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5395053	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5395053	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5395053	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2697490	50.0%
$	899164	16.7%
.	899164	16.7%
	899164	16.7%
,	13	< 0.1%
1	11	< 0.1%
7	8	< 0.1%
2	7	< 0.1%
6	7	< 0.1%
9	7	< 0.1%
Other values (4)	18	< 0.1%

MIS_Status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	1997
Missing (%)	0.2%
Memory size	6.9 MiB

P I F	739609
CHGOFF	157558

Length

Max length	6
Median length	5
Mean length	5.1756172
Min length	5

Characters and Unicode

Total characters	4643393
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P I F
2nd row	P I F
3rd row	P I F
4th row	P I F
5th row	P I F

Common Values

Value	Count	Frequency (%)
P I F	739609	82.3%
CHGOFF	157558	17.5%
(Missing)	1997	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
p	739609	31.1%
i	739609	31.1%
f	739609	31.1%
chgoff	157558	6.6%

Most occurring characters

Value	Count	Frequency (%)
	1479218	31.9%
F	1054725	22.7%
P	739609	15.9%
I	739609	15.9%
C	157558	3.4%
H	157558	3.4%
G	157558	3.4%
O	157558	3.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4643393	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1479218	31.9%
F	1054725	22.7%
P	739609	15.9%
I	739609	15.9%
C	157558	3.4%
H	157558	3.4%
G	157558	3.4%
O	157558	3.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4643393	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1479218	31.9%
F	1054725	22.7%
P	739609	15.9%
I	739609	15.9%
C	157558	3.4%
H	157558	3.4%
G	157558	3.4%
O	157558	3.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4643393	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1479218	31.9%
F	1054725	22.7%
P	739609	15.9%
I	739609	15.9%
C	157558	3.4%
H	157558	3.4%
G	157558	3.4%
O	157558	3.4%

ChgOffPrinGr
Text

Distinct	83165
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	14
Median length	6
Mean length	6.8997235
Min length	6

Characters and Unicode

Total characters	6203983
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	52342 ?
Unique (%)	5.8%

Sample

1st row	$0.00
2nd row	$0.00
3rd row	$0.00
4th row	$0.00
5th row	$0.00

Value	Count	Frequency (%)
0.00	737152	82.0%
50,000.00	2110	0.2%
10,000.00	1865	0.2%
25,000.00	1371	0.2%
35,000.00	1345	0.1%
100,000.00	1028	0.1%
20,000.00	594	0.1%
30,000.00	492	0.1%
15,000.00	467	0.1%
5,000.00	356	< 0.1%
Other values (83155)	152384	16.9%

Most occurring characters

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6203983	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6203983	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6203983	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2643222	42.6%
$	899164	14.5%
.	899164	14.5%
	899164	14.5%
,	161591	2.6%
1	98607	1.6%
2	88727	1.4%
4	86077	1.4%
9	81470	1.3%
3	79226	1.3%
Other values (4)	267571	4.3%

GrAppv
Text

Distinct	22128
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	14
Median length	12
Mean length	11.513319
Min length	8

Characters and Unicode

Total characters	10352362
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13651 ?
Unique (%)	1.5%

Sample

1st row	$60,000.00
2nd row	$40,000.00
3rd row	$287,000.00
4th row	$35,000.00
5th row	$229,000.00

Value	Count	Frequency (%)
50,000.00	69394	7.7%
25,000.00	51258	5.7%
100,000.00	50977	5.7%
10,000.00	38366	4.3%
150,000.00	27624	3.1%
20,000.00	23434	2.6%
35,000.00	23181	2.6%
30,000.00	21004	2.3%
5,000.00	19146	2.1%
15,000.00	18472	2.1%
Other values (22118)	556308	61.9%

Most occurring characters

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10352362	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10352362	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10352362	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4946152	47.8%
,	925342	8.9%
.	899164	8.7%
$	899164	8.7%
	899164	8.7%
5	450225	4.3%
1	345271	3.3%
2	266534	2.6%
3	180629	1.7%
4	133995	1.3%
Other values (4)	406722	3.9%

SBA_Appv
Text

Distinct	38326
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	14
Median length	11
Mean length	11.308074
Min length	8

Characters and Unicode

Total characters	10167813
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23260 ?
Unique (%)	2.6%

Sample

1st row	$48,000.00
2nd row	$32,000.00
3rd row	$215,250.00
4th row	$28,000.00
5th row	$229,000.00

Value	Count	Frequency (%)
25,000.00	49579	5.5%
12,500.00	40147	4.5%
5,000.00	31135	3.5%
50,000.00	25047	2.8%
10,000.00	17009	1.9%
17,500.00	16141	1.8%
15,000.00	14490	1.6%
7,500.00	12781	1.4%
127,500.00	11946	1.3%
80,000.00	10965	1.2%
Other values (38316)	669924	74.5%

Most occurring characters

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10167813	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10167813	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10167813	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4048030	39.8%
,	908994	8.9%
.	899164	8.8%
$	899164	8.8%
	899164	8.8%
5	654346	6.4%
2	433556	4.3%
1	386969	3.8%
7	251493	2.5%
3	186643	1.8%
Other values (4)	600290	5.9%

Interactions

Correlations

	BalanceGross	CreateJob	FranchiseCode	LoanNr_ChkDgt	LowDoc	MIS_Status	NAICS	NewExist	NoEmp	RetainedJob	RevLineCr	Term	UrbanRural	Zip
BalanceGross	1.000	0.000	0.005	0.001	0.000	0.000	0.001	0.000	0.000	0.000	0.000	0.000	0.002	0.001
CreateJob	0.000	1.000	-0.054	-0.031	0.003	0.012	0.157	0.009	0.034	0.377	0.011	0.082	0.025	0.026
FranchiseCode	0.005	-0.054	1.000	0.392	0.014	0.022	-0.091	0.099	0.121	-0.263	0.044	0.196	0.013	0.031
LoanNr_ChkDgt	0.001	-0.031	0.392	1.000	0.110	0.237	-0.050	0.062	0.075	-0.142	0.084	0.121	0.189	0.031
LowDoc	0.000	0.003	0.014	0.110	1.000	0.088	0.060	0.116	0.000	0.003	0.087	0.068	0.157	0.059
MIS_Status	0.000	0.012	0.022	0.237	0.088	1.000	0.148	0.022	0.004	0.013	0.146	0.492	0.211	0.081
NAICS	0.001	0.157	-0.091	-0.050	0.060	0.148	1.000	0.094	-0.154	0.271	0.124	-0.081	0.432	-0.034
NewExist	0.000	0.009	0.099	0.062	0.116	0.022	0.094	1.000	0.005	0.002	0.065	0.088	0.030	0.088
NoEmp	0.000	0.034	0.121	0.075	0.000	0.004	-0.154	0.005	1.000	0.124	0.000	0.200	0.010	0.059
RetainedJob	0.000	0.377	-0.263	-0.142	0.003	0.013	0.271	0.002	0.124	1.000	0.010	-0.157	0.025	-0.026
RevLineCr	0.000	0.011	0.044	0.084	0.087	0.146	0.124	0.065	0.000	0.010	1.000	0.140	0.348	0.056
Term	0.000	0.082	0.196	0.121	0.068	0.492	-0.081	0.088	0.200	-0.157	0.140	1.000	0.207	0.142
UrbanRural	0.002	0.025	0.013	0.189	0.157	0.211	0.432	0.030	0.010	0.025	0.348	0.207	1.000	0.126
Zip	0.001	0.026	0.031	0.031	0.059	0.081	-0.034	0.088	0.059	-0.026	0.056	0.142	0.126	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	LoanNr_ChkDgt	Name	City	State	Zip	Bank	BankState	NAICS	ApprovalDate	ApprovalFY	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	ChgOffDate	DisbursementDate	DisbursementGross	BalanceGross	MIS_Status	ChgOffPrinGr	GrAppv	SBA_Appv
0	1000014003	ABC HOBBYCRAFT	EVANSVILLE	IN	47711	FIFTH THIRD BANK	OH	451120	28-Feb-97	1997	84	4	2.0	0	0	1	N	Y	NaN	28-Feb-99	$60,000.00	$0.00	P I F	$0.00	$60,000.00	$48,000.00
1	1000024006	LANDMARK BAR & GRILLE (THE)	NEW PARIS	IN	46526	1ST SOURCE BANK	IN	722410	28-Feb-97	1997	60	2	2.0	0	0	1	N	Y	NaN	31-May-97	$40,000.00	$0.00	P I F	$0.00	$40,000.00	$32,000.00
2	1000034009	WHITLOCK DDS, TODD M.	BLOOMINGTON	IN	47401	GRANT COUNTY STATE BANK	IN	621210	28-Feb-97	1997	180	7	1.0	0	0	1	N	N	NaN	31-Dec-97	$287,000.00	$0.00	P I F	$0.00	$287,000.00	$215,250.00
3	1000044001	BIG BUCKS PAWN & JEWELRY, LLC	BROKEN ARROW	OK	74012	1ST NATL BK & TR CO OF BROKEN	OK	0	28-Feb-97	1997	60	2	1.0	0	0	1	N	Y	NaN	30-Jun-97	$35,000.00	$0.00	P I F	$0.00	$35,000.00	$28,000.00
4	1000054004	ANASTASIA CONFECTIONS, INC.	ORLANDO	FL	32801	FLORIDA BUS. DEVEL CORP	FL	0	28-Feb-97	1997	240	14	1.0	7	7	1	N	N	NaN	14-May-97	$229,000.00	$0.00	P I F	$0.00	$229,000.00	$229,000.00
5	1000084002	B&T SCREW MACHINE COMPANY, INC	PLAINVILLE	CT	6062	TD BANK, NATIONAL ASSOCIATION	DE	332721	28-Feb-97	1997	120	19	1.0	0	0	1	N	N	NaN	30-Jun-97	$517,000.00	$0.00	P I F	$0.00	$517,000.00	$387,750.00
6	1000093009	MIDDLE ATLANTIC SPORTS CO INC	UNION	NJ	7083	WELLS FARGO BANK NATL ASSOC	SD	0	2-Jun-80	1980	45	45	2.0	0	0	0	N	N	24-Jun-91	22-Jul-80	$600,000.00	$0.00	CHGOFF	$208,959.00	$600,000.00	$499,998.00
7	1000094005	WEAVER PRODUCTS	SUMMERFIELD	FL	34491	REGIONS BANK	AL	811118	28-Feb-97	1997	84	1	2.0	0	0	1	N	Y	NaN	30-Jun-98	$45,000.00	$0.00	P I F	$0.00	$45,000.00	$36,000.00
8	1000104006	TURTLE BEACH INN	PORT SAINT JOE	FL	32456	CENTENNIAL BANK	FL	721310	28-Feb-97	1997	297	2	2.0	0	0	1	N	N	NaN	31-Jul-97	$305,000.00	$0.00	P I F	$0.00	$305,000.00	$228,750.00
9	1000124001	INTEXT BUILDING SYS LLC	GLASTONBURY	CT	6073	WEBSTER BANK NATL ASSOC	CT	0	28-Feb-97	1997	84	3	2.0	0	0	1	N	Y	NaN	30-Apr-97	$70,000.00	$0.00	P I F	$0.00	$70,000.00	$56,000.00

	LoanNr_ChkDgt	Name	City	State	Zip	Bank	BankState	NAICS	ApprovalDate	ApprovalFY	Term	NoEmp	NewExist	FranchiseCode	RevLineCr	LowDoc	ChgOffDate	DisbursementDate	DisbursementGross	BalanceGross	MIS_Status	ChgOffPrinGr	GrAppv	SBA_Appv
899154	9995423005	LITWIN LIVERY SERVICES, INC.	CAMPBELL	OH	44405	JPMORGAN CHASE BANK NATL ASSOC	IL	0	27-Feb-97	1997	60	1	1.0	1	0	N	NaN	30-Sep-97	$10,000.00	$0.00	P I F	$0.00	$10,000.00	$5,000.00
899155	9995453003	FUTURE LEADERS CENTER, INC.	SO. OZONE PARK	NY	11420	FLUSHING BANK	NY	624410	27-Feb-97	1997	180	2	1.0	1	0	N	NaN	30-Jun-97	$123,000.00	$0.00	P I F	$0.00	$128,000.00	$96,000.00
899156	9995473009	FABRICATORS STEEL, INC.	BALTIMORE	MD	21224	BANK OF AMERICA NATL ASSOC	MD	332431	27-Feb-97	1997	60	20	1.0	1	0	N	NaN	30-Jun-97	$50,000.00	$0.00	P I F	$0.00	$50,000.00	$25,000.00
899157	9995493004	PULLTARPS MFG.	EL CAJON	CA	92020	U.S. BANK NATIONAL ASSOCIATION	CA	314912	27-Feb-97	1997	36	40	1.0	1	N	N	NaN	31-Mar-97	$200,000.00	$0.00	P I F	$0.00	$200,000.00	$150,000.00
899158	9995563001	SHADES WINDOW TINTING AUTO ALA	IRVING	TX	75062	LOANS FROM OLD CLOSED LENDERS	DC	0	27-Feb-97	1997	84	5	2.0	1	N	Y	NaN	30-Jun-97	$79,000.00	$0.00	P I F	$0.00	$79,000.00	$63,200.00
899159	9995573004	FABRIC FARMS	UPPER ARLINGTON	OH	43221	JPMORGAN CHASE BANK NATL ASSOC	IL	451120	27-Feb-97	1997	60	6	1.0	1	0	N	NaN	30-Sep-97	$70,000.00	$0.00	P I F	$0.00	$70,000.00	$56,000.00
899160	9995603000	FABRIC FARMS	COLUMBUS	OH	43221	JPMORGAN CHASE BANK NATL ASSOC	IL	451130	27-Feb-97	1997	60	6	1.0	1	Y	N	NaN	31-Oct-97	$85,000.00	$0.00	P I F	$0.00	$85,000.00	$42,500.00
899161	9995613003	RADCO MANUFACTURING CO.,INC.	SANTA MARIA	CA	93455	RABOBANK, NATIONAL ASSOCIATION	CA	332321	27-Feb-97	1997	108	26	1.0	1	N	N	NaN	30-Sep-97	$300,000.00	$0.00	P I F	$0.00	$300,000.00	$225,000.00
899162	9995973006	MARUTAMA HAWAII, INC.	HONOLULU	HI	96830	BANK OF HAWAII	HI	0	27-Feb-97	1997	60	6	1.0	1	N	Y	8-Mar-00	31-Mar-97	$75,000.00	$0.00	CHGOFF	$46,383.00	$75,000.00	$60,000.00
899163	9996003010	PACIFIC TRADEWINDS FAN & LIGHT	KAILUA	HI	96734	CENTRAL PACIFIC BANK	HI	0	27-Feb-97	1997	48	1	2.0	1	N	N	NaN	31-May-97	$30,000.00	$0.00	P I F	$0.00	$30,000.00	$24,000.00

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length